package com.topisv.tms.repository.stock;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.topisv.tms.entity.stock.StockBoxCode;

/**
 * 存储箱条码_dao
 * @author ch
 *
 */
public abstract interface StockBoxCodeDao extends PagingAndSortingRepository<StockBoxCode, Long>, JpaSpecificationExecutor<StockBoxCode>
{

	@Query("select t from StockBoxCode t where t.customerCode=? and t.warehouseCode=?")
	StockBoxCode loadByCondition(String customerCode, String warehouseCode);
}